No

Field

Type

Width

Description

1.  

Loan Number

Character

8

This has to be an existing loan number in the Loan Performer database. Loan has to have been disbursed and not fully repaid.

2.  

Repayment Date

Date

8

Note that this date should be on or after the disbursement date and after any other repayment.

3.  

Repaid Amount

Number

15

4.  

Mode

Number

1

Disbursement mode (1=Cash, 2=cheque, 3=transfer from savings).

5.  

Cheque No.

Character

10

6.  

Recalculate

Character

1

Character Field:  If blank assumes no 1. Recalculate Interest: in case of declining balance, you may want to calculate interest: 1=not recalculate interest,  1=recalculate interest.

7.  

Voucher No.

Character

10

8.  

GL. Account

Character

6

General Ledger cash or bank account. This is the Loan Performer GL A/C for the account that you use for depositing your cheques or cash. You will have to fill this in, even if you have no repayments by cheque or even if you don’t use Loan Performer for your accounting. The GL account should be an existing account.

9.  

Cleared

Character

1

This field indicates whether - in case of a disbursement by cheque - the cheque is cleared or not. It should either be empty, or have a "Y" or "N" value.

10.              

Clearing date

Date

8

If the cheque is cleared then enter the clearing date. The date should be on or after the repayment date. Empty for non cheque payments.

11.              

Member No.

Character

4

This field is only needed if you have tracking of group loans enabled (see Configuration/Loans Part 1). The field stands for the member number in the group.  The number should exist as a member number in the group.